SELECT T.* FROM C1_DICTIONARY T WHERE t.code = :code AND t.type_code = :typeCode
order by t.ORDER_NUM
